Stored Procedures [dbo].[BAEOrderSuperProductChildProductUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@OrderSuperProductChildProductIDint4
@OrderProductIDint4
@ProductCodevarchar(64)64
@DefaultForPricebit1
@Titlevarchar(128)128
SQL Script
create procedure [dbo].[BAEOrderSuperProductChildProductUpdate] @OrderSuperProductChildProductID as
int,
    @OrderProductID AS int,
    @ProductCode AS varchar(64),
    @DefaultForPrice AS bit,
    @Title AS varchar(128)
AS
    UPDATE OrderSuperProductChildProduct
    SET
    OrderProductID =         @OrderProductID,            
    ProductCode =     @ProductCode,            
    DefaultForPrice = @DefaultForPrice,                
    Title = @Title            

    WHERE OrderSuperProductChildProductID = @OrderSuperProductChildProductID;

GO
Uses